The Course Manager Loader enables you to bulk Update or create new LearnCenter (WYSIWYG) or Document Courses and update Existing SCORM and AICC Courses. You can also create Courses based on template Courses you have already created. This loader expects the following items to be preexisting to create LearnCenter (WYSIWYG) Courses:
Bulk Loader data files do not support characters with the grave accent. |
Text Editor | Column | Required | Notes |
---|---|---|---|
1 | A |
|
Course Type |
Accepted Values |
The Course Completion loader will create or update User completion records for the following Course types:
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
Classes are not supported for loading completions | |||
Use Caution. When using the Course ID as the Unique identifier it is possible to update existing Courses in the current LearnCenter or any Sub-LearnCenter |
Text Editor | Column | Required | Notes |
---|---|---|---|
2 | B |
|
Course Name The name is the used to find existing Courses. |
Accepted Values |
Any Value up to 1000 characters in length |
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
Use Caution. When using the Course ID as the Unique identifier it is possible to update existing Courses in the current LearnCenter or any Sub-LearnCenter. |
Text Editor | Column | Required | Notes |
---|---|---|---|
3 | C |
|
Course ID |
Accepted Values |
The LearnCenter System generated Course ID |
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
The Course ID is the Primary Identifier to find existing Course, if included in the data file the Course Type and Name fields will not be used to find the existing Course. | |||
The Course ID can be retrieved using BI Reporting and running the standard Course List Report. In the report add the Course ID, this is the system generated Course ID to add to the data file. | |||
Use Caution. When using the Course ID as the Unique identifier it is possible to update existing Courses in the current LearnCenter or any Sub-LearnCenter. |
Text Editor | Column | Required | Notes |
---|---|---|---|
4 | D |
|
Course Description |
Accepted Values |
Any Value up to 4000 characters in length |
||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
Text Editor | Column | Required | Notes |
---|---|---|---|
5 | E |
|
Set the LearnCenter Course to be included in the Learn Advanced Search. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
Text Editor | Column | Required | Notes |
---|---|---|---|
6 | F |
|
Electronic Signature Name |
Accepted Values |
Any Electronic Signature Name |
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
This field sets the Electronic Signature for the beginning of the Course only. |
Text Editor | Column | Required | Notes |
---|---|---|---|
7 | G |
|
Electronic Signature Name |
Accepted Values |
Any Electronic Signature Name |
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
This field set the Electronic Signature for the end of the Course only |
Text Editor | Column | Required | Notes |
---|---|---|---|
8 | H |
|
Set the Course to be displayed in the Public Catalog. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
This field set the Electronic Signature for the end of the Course only |
Text Editor | Column | Required | Notes |
---|---|---|---|
9 | I |
|
Set the Feedback Form to be displayed to the User after the Course. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
Text Editor | Column | Required | Notes |
---|---|---|---|
10 | J |
|
Set the Always Show Next button. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | No (Field Skipped) |
Applies to Legacy Standard Course Player |
Text Editor | Column | Required | Notes |
---|---|---|---|
11 | K |
|
Set navigation button to center. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | No (Field Skipped) |
Applies to Legacy Standard Course Player |
Text Editor | Column | Required | Notes |
---|---|---|---|
12 | L |
|
Set Navigation Buttons to show. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | No (Field Skipped) |
Applies to Legacy Standard Course Player |
Text Editor | Column | Required | Notes |
---|---|---|---|
13 | M |
|
Set Course Player to show information bar. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | No (Field Skipped) |
Applies to Legacy Standard Course Player |
Text Editor | Column | Required | Notes |
---|---|---|---|
14 | N |
|
Set Course Player to close external window. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
No (Field Skipped) | Yes | Yes | No (Field Skipped) |
Applies to Legacy Standard Course Player. Close on SCORM API Session Finish applies to SCORM 1.2 and 2004 Courses. |
Text Editor | Column | Required | Notes |
---|---|---|---|
15 | O |
|
Set Course Scoring Behavior. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | No (Field Skipped) |
Text Editor | Column | Required | Notes |
---|---|---|---|
16 | P |
|
Sets Keep Session Alive to Active on Inactive. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
Text Editor | Column | Required | Notes |
---|---|---|---|
17 | Q |
No |
Set SCORM Course Auto-Commit Completion/Bookmarking Elements. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
No (Field Skipped) | Yes | No (Field Skipped) | No (Field Skipped) |
Applies to SCORM Courses only |
Text Editor | Column | Required | Notes |
---|---|---|---|
18 | R |
No |
Set Course Player to Use AJAX Communication. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
No (Field Skipped) | Yes | No (Field Skipped) | No (Field Skipped) |
Applies to SCORM Courses only | |||
Applies to Legacy Standard Course Player. |
Text Editor | Column | Required | Notes |
19 | S |
No |
Set Course Commit Behavior. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses. |
No (Field Skipped) | Yes | No (Field Skipped) | No (Field Skipped) |
Applies to SCORM Courses only | |||
Applies to Legacy Standard Course Player. |
Text Editor | Column | Required | Notes |
20 | T |
No |
Set Course Failed Completion Status. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
No (Field Skipped) | Yes | No (Field Skipped) | No (Field Skipped) |
Applies to SCORM Courses only | |||
Applies to Legacy Standard Course Player. |
Text Editor | Column | Required | Notes |
21 | U |
No |
Set Standard Course Player to Show Header. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | No (Field Skipped) |
Applies to Legacy Standard Course Player. |
Text Editor | Column | Required | Notes |
22 | V |
No |
Sets the Display Course Completion Certificate for the Course. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
Mapping of a specific Completion Certificate is completed in the Control Panel > Advanced Learning >Certificates |
Text Editor | Column | Required | Notes |
23 | W |
No |
Set the Course Author Standard Field. |
Accepted Values |
Any value up to 50 characters |
||
Example: Don Bircher |
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
Text Editor | Column | Required | Notes |
24 | X |
No |
Set the Course Series Number Standard Field . |
Accepted Values |
Any value up to 50 characters |
||
Example: Series 101 |
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
Text Editor | Column | Required | Notes |
25 | Y |
No |
Set the Course Series Number Standard Field. |
Accepted Values |
Any value up to 50 characters |
||
Example: Series 101 |
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
Text Editor | Column | Required | Notes |
26 | Z |
No |
Set the Course Series Number Standard Field Set the Course Series Number Standard Field. |
Accepted Values |
Any value up to 50 characters |
||
Example: Level 101 |
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
Text Editor | Column | Required | Notes |
27 | AA |
No |
Set the Course Credits Standard Field. |
Accepted Values |
Numeric value from 0 to 9999999 |
||
Example: 10 |
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
Text Editor | Column | Required | Notes |
28 | AB |
No |
Set the Course Duration Standard Field. |
Accepted Values |
Numeric value from 0 to 99999999 |
||
Example: 10 |
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
Text Editor | Column | Required | Notes |
29 | AC |
No |
Set the Course Publisher Standard Field. |
Accepted Values |
Any value up to 50 characters |
||
Example: Published by ABC Company |
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
Text Editor | Column | Required | Notes |
30 | AD |
No |
Set the Course Cost Per User Standard Field. |
Accepted Values |
Numeric value from 0 to 9999999 |
||
Example: 100 |
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
Text Editor | Column | Required | Notes |
31 | AE |
No |
Set the Course Number Standards Field. |
Accepted Values |
Any value up to 50 characters |
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
Text Editor | Column | Required | Notes |
32 | AF |
No |
Places the Course in the Warehouse or Showroom (Inserted into the LearnCenter). |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
Using the update existing records the Course can be moved between the Warehouse and Showroom Course must be in the Showroom (inserted into the LearnCenter) to report on progress for the Course. |
Text Editor | Column | Required | Notes |
33 | AG |
No |
Populates custom fields with Default Values. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
Text Editor | Column | Required | Notes |
34 | AH |
No |
Set the Course Custom Fields. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
Custom Field must exist and have unique names If more than one Course custom field is found with the same name this will be an error condition and outputted to the results file.. |
Text Editor | Column | Required | Notes |
35 | AI |
No |
Set the Course Categories. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
Text Editor | Column | Required | Notes |
36 | AJ |
No |
Creates the new Course from an existing template Course. |
Accepted Values |
|
||
Example: Template Placeholder Course |
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | No (Field Skipped) | No (Field Skipped) | Yes |
The Loader will create the new Course from an existing LearnCenter Course including the copying the HTML from the Course Chapters and pages. The New Course will be an exact copy of the existing Template Course |
Text Editor | Column | Required | Notes |
37 | AK |
No |
Set the LearnCenter Course Player to Show Navigation Bar |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
No (Field Skipped) | Yes | Yes | No (Field Skipped) |
Applies to the LearnCenter Course Player only |
Text Editor | Column | Required | Notes |
38 | AL |
No |
Set the LearnCenter Course Player to Show Navigation Bar Location. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
No (Field Skipped) | Yes | No (Field Skipped) | Yes |
Applies to the LearnCenter Course Player only |
Text Editor | Column | Required | Notes |
39 | AM |
No |
No Set the LearnCenter Course Player to Show Navigation Buttons. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
No (Field Skipped) | Yes | No (Field Skipped) | Yes |
Applies to the LearnCenter Course Player only |
Text Editor | Column | Required | Notes |
40 | AN |
No |
Set the LearnCenter Course Player Height when launched in a Widget. |
Accepted Values |
Numeric value from 1 to 9999 |
||
Example: 1024 |
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
No (Field Skipped) | Yes | No (Field Skipped) | Yes |
Applies to the LearnCenter Course Player only |
Text Editor | Column | Required | Notes |
41 | AO |
No |
Overrides the LearnCenter setting to set Expire Attempts at the individual Course Level. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
No Values will clear the setting at the Course level and Course will Inherit the LearnCenter setting | |||
Never, On, or After will override the LearnCenter level setting and set the Expire Attempts at the Course level. | |||
When you select On, column 42 is required to have the date to Expire the Attempts | |||
When you select After, column 43 and 44 are required to have the interval to expire the attempt |
Text Editor | Column | Required | Notes |
42 | AP |
Yes If Column 41 = On |
Overrides the LearnCenter setting to set Expire Attempts at the individual Course Level on a defined number of Days =, Mounts, or Years. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
Required if Column 41 Expire Attempts - Override LearnCenter Default is set to On | |||
See Requirements for Bulk Loader Source Files for information on formatting dates. | |||
Custom Excel Field Type Format: mm/dd/yyyy |
Text Editor | Column | Required | Notes |
43 | AQ |
Yes If Column 41 = After |
Overrides the LearnCenter setting to set Expire Attempts at the individual Course Level. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
Required if Column 41 Expire Attempts - Override LearnCenter Default is set to On |
Text Editor | Column | Required | Notes |
44 | AR |
Yes If Column 41 = After |
Attempts at the individual Course Level. |
Accepted Values |
Numeric value from 1 to 9999 |
||
Example: 90 |
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
Required if Column 41 Expire Attempts - Override LearnCenter Default is set to On |
Text Editor | Column | Required | Notes |
45 | AS |
No |
Overrides the LearnCenter setting to set Expire Completions at the individual Course Level. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
No Values will clear the setting at the Course level and Course will Inherit the LearnCenter setting | |||
Selecting Never, On, or After will override the LearnCenter level setting and set the Expire Completions at the Course level. | |||
When you select On, column 46 is required to have the date to Expire the Completions | |||
When you select After, then column 47 and 48 are required to have the interval to expire the Completion |
Text Editor | Column | Required | Notes |
46 | AT |
Yes If Column 45 = On |
Overrides the LearnCenter setting to set Expire Completions at the individual Course Level on a defined number of Days =, Mounts, or Years. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
Required if Column 45 Expire Completions - Override LearnCenter Default is set to On. | |||
See Requirements for Bulk Loader Source Files for information on formatting dates. | |||
Custom Excel Field Type Format: mm/dd/yyyy |
Text Editor | Column | Required | Notes |
47 | AU |
Yes If Column 45 = After |
Overrides the LearnCenter setting to set Expire Completions at the individual Course Level. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
Required if Column 45 Expire Completions - Override LearnCenter Default is set to After. |
Text Editor | Column | Required | Notes |
48 | AV |
Yes If Column 41 = After |
Overrides the LearnCenter setting to set Expire Completions at the individual Course Level. |
Accepted Values |
Numeric value from 1 to 9999 |
||
Example: 90 |
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | Yes | Yes |
Required if Column 41 Expire Attempts - Override LearnCenter Default is set to After |
Text Editor | Column | Required | Notes |
49 | AW |
No |
Overrides the LearnCenter setting to set Expire Set the additional completion criteria for the document Course to require view all pages. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
No (Field Skipped) | No (Field Skipped) | No (Field Skipped) | Yes |
Text Editor | Column | Required | Notes |
50 | AX |
No |
Set the additional completion criteria for the document Course to require a minimum time in the Course. |
Accepted Values |
|
||
|
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
No (Field Skipped) | No (Field Skipped) | No (Field Skipped) | Yes |
Applies to Document Courses created from the Content Manager. | |||
Refer to the Bulk Data Loader Working With Microsoft Excel for Tips on formatting your Microsoft Excel Source file to set the date format correctly in your upload data file. | |||
Custom Excel Field Type Format: hh:mm:ss |
Text Editor | Column | Required | Notes |
51 | AY |
No |
Indicates whether you want to download the document course to download. |
Accepted Values |
|
||
|
Text Editor | Column | Required | Notes |
52 | AZ |
No |
Indicates your LearnCenter Course Player Launch Mode preference |
Accepted Values |
|
||
Example: Embed Example: New Window or Tab |
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
Yes | Yes | No (Field Skipped) | Yes |
Text Editor | Column | Required | Notes |
53 | BA |
No |
Sets your preference for multiple attempts for the Document or SCORM 1.2 Course. |
Accepted Values |
|
||
Example: Yes Example: No |
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
No (Field Skipped) | Yes | No (Field Skipped) | Yes |
Text Editor | Column | Required | Notes |
54 | BB |
No |
Updates the file path to the SFTP location for a SCORM Course. |
Accepted Values |
|
||
Example: /files/scorm/<Path to Course> |
|||
Course Types Supported by this Field | |||
LearnCenter Courses | SCORM Courses | AICC Courses | Document Courses |
No (Field Skipped) | Yes | No (Field Skipped) | No (Field Skipped) |
IMPORTANT: Use the field only if the SCORM Course path has been moved or renamed on the SFTP after import and the Course is being launched in the LearnCenter Course Player from a Widget. This field cannot be used to update a path for the Standard or Classic Course Player. | |||
Refer to the Bulk Data Loader Working With Microsoft Excel for Tips on formatting your Microsoft Excel Source file to set the date format correctly in your upload data file. | |||
Applies only to SCORM 1.2 Course being launched from the LearnCenter Course Player. |
Copyright © 2010-2018, Oracle and/or its affiliates. All rights reserved.